{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Performance Appraisal","Goals and Objectives","ranking","Formulas"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Performance Appraisal","index":0,"n_rows":78,"n_cols":4,"rows_kept":78,"cut":false,"hidden":false,"merged":[[54,0,56,3],[13,0,13,3],[11,0,11,3],[10,0,10,3],[9,0,9,3],[12,0,12,3],[14,0,14,3],[0,0,0,3],[16,0,16,3],[15,0,15,3],[53,0,53,3],[2,1,2,3],[1,1,1,3],[3,1,3,3],[8,0,8,3],[68,0,68,2],[57,0,57,3],[58,0,60,3],[61,0,61,3],[62,0,67,3]]}
["College of Business and Economics                                                              ADMINISTRATIVE  PERFORMANCE APPRAISAL"]
[]
["Name/Date","Title"]
[]
["Department",null,"Probationary Y/N"]
["EVALUATION PERIOD                                                                                  From: Month/Year"]
["To: Month/Year"]
[]
["Performance Rating"]
["Excellent - This level is reserved for truly exceptional performance.  Performance is far above the defined job expectations.  Results are consistently excellent and consistently exceeds project goals and objectives.  The employee consistently does outstanding work, regularly going far beyond what is expected of employees in this job.  Skill level is clearly superior.  Key behaviors are exemplary.  Excellent performance is due to the effort and skills of the employee. "]
["Good - This is a level of high quality performance.  Performance meets the defined job expectations and frequently exceeds job expectations.  Results are consistently above average and consistently meets or exceeds project goals and objectives. The employee consistently does good work, regularly going beyond what is expected of employees in this job.  The employee is generally doing a very good job.  Skill level is above average.   Key behaviors are above average.  Good performance is due to the effort and skills of the employee."]
["Satisfactory - This level represents satisfactory performance.  Performance meets the defined job expectations. The employee generally performs according to the expectations of the job. The employee is doing the job at the level expected for employees in this position.  Skill level is competent.  Key behaviors are acceptable. Satisfactory performance is due to the effort and skills of the employee."]
["Needs Improvement - This represents an inconsistent performance at a level less than what is normally expected in this position. A performance improvement plan must be attached that identifies what should be done to improve performance and a time frame within it must be accomplished."]
["Unsatisfactory - Performance generally fails to meet the defined expectations of the job or requires frequent, close supervision and/or the redoing of work. The employee is not consistently doing the job at the level expected for employees in this position.  Job skills and/or their use are at an unacceptable level.  Key behaviors are unacceptable.  Unsuccessful job performance is due to the lack of effort and skills of the employee."]
["Not Applicable - Insufficient information exists to evaluate this element of the employee's performance."]
["Criteria Weighting (all categories should total 100)"]
["The weight assigned to each category will be multiplied by the average ratings for each category                                                                               (Unsatisfactory 0 points, Not Applicable 0 points, Needs Improvement 1.0 point, Satisfactory 1.6 points, Good 2.3 points, Excellent 3 points)"]
["TOTAL"]
["ADMINISTRATIVE COMPETENCIES","Weight","Performance Rating","Weighted Points"]
["Builds an effective team and identifies optimal staffing levels necessary to effectively conduct the business of the unit.",0,null,{"$f":"B20*Formulas!B2","v":0}]
["Creates effective work plans; identifies the correct resources and processes; sets priorities; delegates authority and meets deadlines. Incorporates adequate control systems to monitor workflow.",0,null,{"$f":"B21*Formulas!B3","v":0}]
["Creates an environment in which information flows smoothly between self and others and encourages open expression of ideas and opinions by subordinates. Conveys information clearly and in a timely manner; prepares concise written reports; makes effective presentations.",0,null,{"$f":"B22*Formulas!B4","v":0}]
["Demonstrates the importance of sound performance and productivity; operates within budget; recommends methods to reduce costs and/or improve operations.",null,null,{"$f":"B23*Formulas!B5","v":0}]
["Evaluates performance based on results.",null,null,{"$f":"B24*Formulas!B6","v":0}]
["Empowers staff to take responsibility for their work processes; removes obstacles that hinder progress.",null,null,{"$f":"B25*Formulas!B7","v":0}]
["Category Total",{"$f":"SUM(B20:B25)","v":0},null,{"$f":"SUM(D20:D25)","v":0}]
[]
["LEADERSHIP ","Weight","Performance Rating","Weighted Points"]
["Communicates the University's and College's vision and mission to staff members; shapes behavior in order to turn the vision and mission into reality. Actions are consistent with language.",null,null,{"$f":"B29*Formulas!B10","v":0}]
["Asserts ideas and persuades others; gains support and commitment; mobilizes people to take action.",null,null,{"$f":"B30*Formulas!B11","v":0}]
["Coaches staff members and accurately assesses their developmental needs; provides specific and frequent feedback on performance.",null,null,{"$f":"B31*Formulas!B12","v":0}]
["Creates an environment conducive to cooperation and trust.",null,null,{"$f":"B32*Formulas!B13","v":0}]
["Acts professionally and responsibly as a agent of the College, within and outside of the College; contributes to a positive image.",null,null,{"$f":"B33*Formulas!B14","v":0}]
["Adjusts to shifting priorities, ambiguity and rapid change; demonstrates flexibility.",null,null,{"$f":"B34*Formulas!B15","v":0}]
["Champions new initiatives; assumes risk and responsibility for the unit; and addresses difficult issues",null,null,{"$f":"B35*Formulas!B16","v":0}]
["Category Total",{"$f":"SUM(B29:B35)","v":0},null,{"$f":"SUM(D29:D35)","v":0}]
[]
["ORGANIZATIONAL and STRATEGIC COMPETENCIES ","Weight","Performance Rating","Weighted Points"]
["Thinks strategically; identifies critical, high pay-off strategies and prioritizes team efforts accordingly; effectively plans for future growth and/or direction.",null,null,{"$f":"B39*Formulas!B19","v":0}]
["Emphasizes the need to deliver quality services; defines standards for quality and evaluates processes against those standards in an effort to improve organizational performance.",null,null,{"$f":"B40*Formulas!B20","v":0}]
["Identifies constituent needs and takes action to meet those needs; continually searches for ways to increase constituent satisfaction.",null,null,{"$f":"B41*Formulas!B21","v":0}]
["Supports the employment, education and development of minorities and protected classes.  Makes and supports decisions based on the principles of Affirmative Action and Equal Employment Opportunity.",null,null,{"$f":"B42*Formulas!B22","v":0}]
["Considers a broad range of internal and external factors when making decisions. Considers the greater good of the college/university over the individual or department.",null,null,{"$f":"B43*Formulas!B23","v":0}]
["Category Total",{"$f":"SUM(B39:B43)","v":0},null,{"$f":"SUM(D39:D43)","v":0}]
[]
["GOALS AND OBJECTIVES","Weight","Performance Rating","Weighted Points"]
["Develops and completes  goals, objectives, and projects that are consistent with the University and College mission, vision, strategy and values.",null,null,{"$f":"B47*Formulas!B26","v":0}]
["Did the Department/Division/Team meet its goals and objectives",null,null,{"$f":"B48*Formulas!B27","v":0}]
["Did the employee accomplish his/her goals and objectives (see objectives tab)",null,null,{"$f":"B49*Formulas!B28","v":0}]
["Category Total",{"$f":"SUM(B47:B49)","v":0},null,{"$f":"SUM(D47:D49)","v":0}]
[]
["SUMMARY  ","Weight",null,"Weighted Points"]
["Total Weighted Points  (Summary of Average Category Points)",{"$f":"B50+B44+B36+B26","v":0},null,{"$f":"D50+D44+D36+D26","v":0}]
["EVALUATOR’S COMMENTS: "]
[]
[]
[]
["DEVELOPMENT PLAN: "]
[]
[]
[]
["EMPLOYEE: Discuss your thoughts on this evaluation and identify the specific ways the College can help you optimize your performance."]
[]
[]
[]
[]
[]
[]
["I have reviewed my job description as of this date and it is consistent with my present position responsibilities."]
[]
[]
["Signature (indicates review and discussion)                      ",null,"Date:"]
[]
[]
["Evaluator's signature:                                                    ",null,"Date:"]
[]
[" "]
["Next level Manager's signature:                                 ",null,"Date:"]

{"sheet":"Goals and Objectives","index":1,"n_rows":28,"n_cols":6,"rows_kept":28,"cut":false,"hidden":false,"merged":[[12,0,12,5],[28,0,28,5],[18,0,18,5],[19,0,19,4],[27,0,27,4],[14,0,14,5],[20,0,20,5],[22,0,22,5],[23,0,23,4],[15,0,15,4],[16,0,16,5],[24,0,24,5],[26,0,26,5],[0,0,0,5],[11,0,11,4],[6,0,6,5],[7,0,7,4],[8,0,8,5],[5,0,5,3],[9,0,9,3],[10,0,10,5],[2,0,2,5],[3,0,3,4],[4,0,4,5],[1,0,1,5]]}
["PERFORMANCE AGAINST GOALS AND OBJECTIVES"]
["Goal/objective/project/assignment"]
[]
["Results achieved",null,null,null,null,"Not Applicable"]
[]
["Goal/objective/project/assignment"]
[]
["Results achieved",null,null,null,null,"Not Applicable"]
[]
["Goal/objective/project/assignment"]
[]
["Results achieved",null,null,null,null,"Not Applicable"]
[]
["Goal/objective/project/assignment"]
[]
["Results achieved",null,null,null,null,"Not Applicable"]
[]
["Goal/objective/project/assignment"]
[]
["Results achieved",null,null,null,null,"Not Applicable"]
[]
["Goal/objective/project/assignment"]
[]
["Results achieved",null,null,null,null,"Not Applicable"]
[]
["Goal/objective/project/assignment"]
[]
["Results achieved",null,null,null,null,"Not Applicable"]

{"sheet":"ranking","index":2,"n_rows":6,"n_cols":1,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
["Not Applicable"]
["Unsatisfactory"]
["Needs Improvement"]
["Satisfactory"]
["Good"]
["Excellent"]

{"sheet":"Formulas","index":3,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["ADMINISTRATIVE COMPETENCIES","Points"]
[{"$f":"'Performance Appraisal'!A20","v":"Builds an effective team and identifies optimal staffing levels necessary to effectively conduct the business of the unit."},{"$f":"IF('Performance Appraisal'!C20=\"Unsatisfactory\",0,IF('Performance Appraisal'!C20=\"Satisfactory\",1.6,IF('Performance Appraisal'!C20=\"Good\",2.3,IF('Performance Appraisal'!C20=\"Excellent\",3,IF('Performance Appraisal'!C20=\"Not Applicable\",0,IF('Performance Appraisal'!C20=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A21","v":"Creates effective work plans; identifies the correct resources and processes; sets priorities; delegates authority and meets deadlines. Incorporates adequate control systems to monitor workflow."},{"$f":"IF('Performance Appraisal'!C21=\"Unsatisfactory\",0,IF('Performance Appraisal'!C21=\"Satisfactory\",1.6,IF('Performance Appraisal'!C21=\"Good\",2.3,IF('Performance Appraisal'!C21=\"Excellent\",3,IF('Performance Appraisal'!C21=\"Not Applicable\",0,IF('Performance Appraisal'!C21=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A22","v":"Creates an environment in which information flows smoothly between self and others and encourages open expression of ideas and opinions by subordinates. Conveys information clearly and in a timely manner; prepares concise written reports; makes effective presentations."},{"$f":"IF('Performance Appraisal'!C22=\"Unsatisfactory\",0,IF('Performance Appraisal'!C22=\"Satisfactory\",1.6,IF('Performance Appraisal'!C22=\"Good\",2.3,IF('Performance Appraisal'!C22=\"Excellent\",3,IF('Performance Appraisal'!C22=\"Not Applicable\",0,IF('Performance Appraisal'!C22=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A23","v":"Demonstrates the importance of sound performance and productivity; operates within budget; recommends methods to reduce costs and/or improve operations."},{"$f":"IF('Performance Appraisal'!C23=\"Unsatisfactory\",0,IF('Performance Appraisal'!C23=\"Satisfactory\",1.6,IF('Performance Appraisal'!C23=\"Good\",2.3,IF('Performance Appraisal'!C23=\"Excellent\",3,IF('Performance Appraisal'!C23=\"Not Applicable\",0,IF('Performance Appraisal'!C23=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A24","v":"Evaluates performance based on results."},{"$f":"IF('Performance Appraisal'!C24=\"Unsatisfactory\",0,IF('Performance Appraisal'!C24=\"Satisfactory\",1.6,IF('Performance Appraisal'!C24=\"Good\",2.3,IF('Performance Appraisal'!C24=\"Excellent\",3,IF('Performance Appraisal'!C24=\"Not Applicable\",0,IF('Performance Appraisal'!C24=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A25","v":"Empowers staff to take responsibility for their work processes; removes obstacles that hinder progress."},{"$f":"IF('Performance Appraisal'!C25=\"Unsatisfactory\",0,IF('Performance Appraisal'!C25=\"Satisfactory\",1.6,IF('Performance Appraisal'!C25=\"Good\",2.3,IF('Performance Appraisal'!C25=\"Excellent\",3,IF('Performance Appraisal'!C25=\"Not Applicable\",0,IF('Performance Appraisal'!C25=\"Needs Improvement\",1))))))","v":false}]
[]
["LEADERSHIP ","Points"]
[{"$f":"'Performance Appraisal'!A29","v":"Communicates the University's and College's vision and mission to staff members; shapes behavior in order to turn the vision and mission into reality. Actions are consistent with language."},{"$f":"IF('Performance Appraisal'!C29=\"Unsatisfactory\",0,IF('Performance Appraisal'!C29=\"Satisfactory\",1.6,IF('Performance Appraisal'!C29=\"Good\",2.3,IF('Performance Appraisal'!C29=\"Excellent\",3,IF('Performance Appraisal'!C29=\"Not Applicable\",0,IF('Performance Appraisal'!C29=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A30","v":"Asserts ideas and persuades others; gains support and commitment; mobilizes people to take action."},{"$f":"IF('Performance Appraisal'!C30=\"Unsatisfactory\",0,IF('Performance Appraisal'!C30=\"Satisfactory\",1.6,IF('Performance Appraisal'!C30=\"Good\",2.3,IF('Performance Appraisal'!C30=\"Excellent\",3,IF('Performance Appraisal'!C30=\"Not Applicable\",0,IF('Performance Appraisal'!C30=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A31","v":"Coaches staff members and accurately assesses their developmental needs; provides specific and frequent feedback on performance."},{"$f":"IF('Performance Appraisal'!C31=\"Unsatisfactory\",0,IF('Performance Appraisal'!C31=\"Satisfactory\",1.6,IF('Performance Appraisal'!C31=\"Good\",2.3,IF('Performance Appraisal'!C31=\"Excellent\",3,IF('Performance Appraisal'!C31=\"Not Applicable\",0,IF('Performance Appraisal'!C31=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A32","v":"Creates an environment conducive to cooperation and trust."},{"$f":"IF('Performance Appraisal'!C32=\"Unsatisfactory\",0,IF('Performance Appraisal'!C32=\"Satisfactory\",1.6,IF('Performance Appraisal'!C32=\"Good\",2.3,IF('Performance Appraisal'!C32=\"Excellent\",3,IF('Performance Appraisal'!C32=\"Not Applicable\",0,IF('Performance Appraisal'!C32=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A33","v":"Acts professionally and responsibly as a agent of the College, within and outside of the College; contributes to a positive image."},{"$f":"IF('Performance Appraisal'!C33=\"Unsatisfactory\",0,IF('Performance Appraisal'!C33=\"Satisfactory\",1.6,IF('Performance Appraisal'!C33=\"Good\",2.3,IF('Performance Appraisal'!C33=\"Excellent\",3,IF('Performance Appraisal'!C33=\"Not Applicable\",0,IF('Performance Appraisal'!C33=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A34","v":"Adjusts to shifting priorities, ambiguity and rapid change; demonstrates flexibility."},{"$f":"IF('Performance Appraisal'!C34=\"Unsatisfactory\",0,IF('Performance Appraisal'!C34=\"Satisfactory\",1.6,IF('Performance Appraisal'!C34=\"Good\",2.3,IF('Performance Appraisal'!C34=\"Excellent\",3,IF('Performance Appraisal'!C34=\"Not Applicable\",0,IF('Performance Appraisal'!C34=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A35","v":"Champions new initiatives; assumes risk and responsibility for the unit; and addresses difficult issues"},{"$f":"IF('Performance Appraisal'!C35=\"Unsatisfactory\",0,IF('Performance Appraisal'!C35=\"Satisfactory\",1.6,IF('Performance Appraisal'!C35=\"Good\",2.3,IF('Performance Appraisal'!C35=\"Excellent\",3,IF('Performance Appraisal'!C35=\"Not Applicable\",0,IF('Performance Appraisal'!C35=\"Needs Improvement\",1))))))","v":false}]
[]
["ORGANIZATIONAL and STRATEGIC COMPETENCIES ","Points"]
[{"$f":"'Performance Appraisal'!A39","v":"Thinks strategically; identifies critical, high pay-off strategies and prioritizes team efforts accordingly; effectively plans for future growth and/or direction."},{"$f":"IF('Performance Appraisal'!C39=\"Unsatisfactory\",0,IF('Performance Appraisal'!C39=\"Satisfactory\",1.6,IF('Performance Appraisal'!C39=\"Good\",2.3,IF('Performance Appraisal'!C39=\"Excellent\",3,IF('Performance Appraisal'!C39=\"Not Applicable\",0,IF('Performance Appraisal'!C39=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A40","v":"Emphasizes the need to deliver quality services; defines standards for quality and evaluates processes against those standards in an effort to improve organizational performance."},{"$f":"IF('Performance Appraisal'!C40=\"Unsatisfactory\",0,IF('Performance Appraisal'!C40=\"Satisfactory\",1.6,IF('Performance Appraisal'!C40=\"Good\",2.3,IF('Performance Appraisal'!C40=\"Excellent\",3,IF('Performance Appraisal'!C40=\"Not Applicable\",0,IF('Performance Appraisal'!C40=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A41","v":"Identifies constituent needs and takes action to meet those needs; continually searches for ways to increase constituent satisfaction."},{"$f":"IF('Performance Appraisal'!C41=\"Unsatisfactory\",0,IF('Performance Appraisal'!C41=\"Satisfactory\",1.6,IF('Performance Appraisal'!C41=\"Good\",2.3,IF('Performance Appraisal'!C41=\"Excellent\",3,IF('Performance Appraisal'!C41=\"Not Applicable\",0,IF('Performance Appraisal'!C41=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A42","v":"Supports the employment, education and development of minorities and protected classes.  Makes and supports decisions based on the principles of Affirmative Action and Equal Employment Opportunity."},{"$f":"IF('Performance Appraisal'!C42=\"Unsatisfactory\",0,IF('Performance Appraisal'!C42=\"Satisfactory\",1.6,IF('Performance Appraisal'!C42=\"Good\",2.3,IF('Performance Appraisal'!C42=\"Excellent\",3,IF('Performance Appraisal'!C42=\"Not Applicable\",0,IF('Performance Appraisal'!C42=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A43","v":"Considers a broad range of internal and external factors when making decisions. Considers the greater good of the college/university over the individual or department."},{"$f":"IF('Performance Appraisal'!C43=\"Unsatisfactory\",0,IF('Performance Appraisal'!C43=\"Satisfactory\",1.6,IF('Performance Appraisal'!C43=\"Good\",2.3,IF('Performance Appraisal'!C43=\"Excellent\",3,IF('Performance Appraisal'!C43=\"Not Applicable\",0,IF('Performance Appraisal'!C43=\"Needs Improvement\",1))))))","v":false}]
[]
["GOALS AND OBJECTIVES","Points"]
[{"$f":"'Performance Appraisal'!A47","v":"Develops and completes  goals, objectives, and projects that are consistent with the University and College mission, vision, strategy and values."},{"$f":"IF('Performance Appraisal'!C47=\"Unsatisfactory\",0,IF('Performance Appraisal'!C47=\"Satisfactory\",1.6,IF('Performance Appraisal'!C47=\"Good\",2.3,IF('Performance Appraisal'!C47=\"Excellent\",3,IF('Performance Appraisal'!C47=\"Not Applicable\",0,IF('Performance Appraisal'!C47=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A48","v":"Did the Department/Division/Team meet its goals and objectives"},{"$f":"IF('Performance Appraisal'!C48=\"Unsatisfactory\",0,IF('Performance Appraisal'!C48=\"Satisfactory\",1.6,IF('Performance Appraisal'!C48=\"Good\",2.3,IF('Performance Appraisal'!C48=\"Excellent\",3,IF('Performance Appraisal'!C48=\"Not Applicable\",0,IF('Performance Appraisal'!C48=\"Needs Improvement\",1))))))","v":false}]
[{"$f":"'Performance Appraisal'!A49","v":"Did the employee accomplish his/her goals and objectives (see objectives tab)"},{"$f":"IF('Performance Appraisal'!C49=\"Unsatisfactory\",0,IF('Performance Appraisal'!C49=\"Satisfactory\",1.6,IF('Performance Appraisal'!C49=\"Good\",2.3,IF('Performance Appraisal'!C49=\"Excellent\",3,IF('Performance Appraisal'!C49=\"Not Applicable\",0,IF('Performance Appraisal'!C49=\"Needs Improvement\",1))))))","v":false}]